{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[8,0,8,9],[9,0,9,9],[10,0,10,9],[8,12,8,20],[9,12,9,20],[10,12,10,20],[11,12,11,20],[12,12,12,20],[13,12,13,20],[11,0,11,9],[12,0,12,9],[15,0,15,9],[16,0,16,9],[17,0,17,9],[13,0,13,9],[14,0,14,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions",null,null,null,null,null,null,null,null,null,null,null,"Notes:"]
["This tool will merge the data from the first sheet/tab of two Excel files (*.xlsx, *.xlsm, *.xls, or *.xlsb) based on a shared identifying column.",null,null,null,null,null,null,null,null,null,null,null,"This tool will only work on Windows versions of Microsoft Excel."]
["If you want to merge data from other sheets, you'll have to rearrange your files.",null,null,null,null,null,null,null,null,null,null,null,"This tool does not work for files stored on OneDrive."]
["The first file that you select will be treated as the \"base\" file.  All the data from the base file will be included in the final result.",null,null,null,null,null,null,null,null,null,null,null,"Although every effort has been made to ensure the accuracy of the software used by this tool, it is provided with absolutely no warranty."]
["The second file you select will be \"left joined\" onto the base file.  This means that rows/data from the second file will only be included in the final result if there are matching rows/data in the base file.",null,null,null,null,null,null,null,null,null,null,null,"The user is solely responsible for the results obtained from the use of this software."]
["The files will be joined according to a shared key/identifying column. ",null,null,null,null,null,null,null,null,null,null,null,"This tool is published under GNU General Public License v3.0."]
["The column headings/names for the key must be identical in both files, but the column can be located anywhere on the first sheet."]
["Any columns that are present in both files will have their names/headers changed. "]
["The columns that come from the base file will have \"a.\" added to the beginning of the name."]
["The columns that come from the second file will have \"b.\" added to the beginning of the name."]
[]
[]
["Example:"]
[]
["File 1",null,null,null,"File 2",null,null,"Result"]
["ID","Age","Sex",null,"ID","Height",null,"a.ID","Age","Sex","b.ID","Height"]
[1,50,"M",null,2,"5' 4\"",null,1,50,"M"]
[2,55,"F",null,3,"5' 9\"",null,2,55,"F",2,"5' 4\""]
[3,60,"M",null,null,null,null,3,60,"M",3,"5' 9\""]
[4,65,"F",null,null,null,null,4,65,"F"]
[5,70,"M",null,null,null,null,5,70,"M"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}